Columns
Grants
Dependencies
Details
Triggers
Errors
Columns
Grants
Dependencies
Details
Triggers
Errors
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS | INSERTABLE | UPDATABLE | DELETABLE |
---|---|---|---|---|---|---|---|---|
OBJ | VARCHAR2(20) | No | null | 1 | null | NO | NO | NO |
ID | VARCHAR2(100) | Yes | null | 2 | null | NO | NO | NO |
TITLE | VARCHAR2(400) | Yes | null | 3 | null | NO | NO | NO |
CREATED_ON | DATE | Yes | null | 4 | null | NO | NO | NO |
STATUS | VARCHAR2(100) | Yes | null | 5 | null | NO | NO | NO |
LEAD | VARCHAR2(400) | Yes | null | 6 | null | NO | NO | NO |
OWNING_UNIT | VARCHAR2(400) | Yes | null | 7 | null | NO | NO | NO |
CREATE_UNIT | VARCHAR2(400) | Yes | null | 8 | null | NO | NO | NO |
RCV_UNIT | VARCHAR2(400) | Yes | null | 9 | null | NO | NO | NO |
REFERRAL_TYPE | VARCHAR2(100) | No | null | 10 | null | NO | NO | NO |
NEXT_DUE_DATE | DATE | Yes | null | 11 | null | NO | NO | NO |
FINAL_DUE_DATE | DATE | Yes | null | 12 | null | NO | NO | NO |
CREATED_ON_FY | NUMBER | Yes | null | 13 | null | NO | NO | NO |
LAST_MODIFIED_DATE | DATE | Yes | null | 14 | null | NO | NO | NO |
SOURCE | VARCHAR2(4000) | Yes | null | 15 | null | NO | NO | NO |
SUBJECTS | VARCHAR2(4000) | Yes | null | 16 | null | NO | NO | NO |
OFFICE | VARCHAR2(4000) | Yes | null | 17 | null | NO | NO | NO |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_CUBE_PARTIC_OUTCOMES_INTERCOMS | VIEW | QART | V_CUBE_INTERCOM_ALL | VIEW |
References
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_CUBE_INTERCOM_ALL | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_CUBE_INTERCOM_ALL | VIEW | QART | MV_ACM_OBJ_TYPE | TABLE |
QART | V_CUBE_INTERCOM_ALL | VIEW | QART | V_CURR_OBJ_LEAD_PERS | VIEW |
QART | V_CUBE_INTERCOM_ALL | VIEW | QART | MV_ACM_REFERENCE | TABLE |
QART | V_CUBE_INTERCOM_ALL | VIEW | QART | V_CURR_OBJ_OWNING_UNIT | VIEW |
QART | V_CUBE_INTERCOM_ALL | VIEW | QART | V_CURR_OBJ_CREATE_UNIT | VIEW |
QART | V_CUBE_INTERCOM_ALL | VIEW | QART | V_CURR_OBJ_RECEIVING_UNIT | VIEW |
QART | V_CUBE_INTERCOM_ALL | VIEW | QART | MV_I_REFERRAL | TABLE |
QART | V_CUBE_INTERCOM_ALL | VIEW | QART | MV_ACM_STATUS | TABLE |
QART | V_CUBE_INTERCOM_ALL | VIEW | QART | MV_ACM_STATUS_HISTORY | TABLE |
QART | V_CUBE_INTERCOM_ALL | VIEW | QART | V_OBJ_PARTICIPANTS | VIEW |
NAME | VALUE |
---|---|
CREATED | 04-APR-23 |
LAST_DDL_TIME | 05-FEB-25 |
OWNER | QART |
VIEW_NAME | V_CUBE_INTERCOM_ALL |
TEXT_LENGTH | 1944 |
TEXT | select o.sid obj, o.id id, o.tagline title, o.created_on, stat.display status, lead.sh_display lead, ou.sh_display owning_unit, cu.sh_display create_unit, ru.sh_display rcv_unit, ot.display referral_type, o.next_due_date, o.final_due_date, o.created_on_fy created_on_fy, o.last_modified_on last_modified_date, ref.display source, OP.SUBJECTS, OP.OFFICE from mv_acm_obj o inner join mv_acm_obj_type ot on o.obj_type = ot.sid and ot.obj_root in ('INTERCOM') left outer join (select obj, sh_obj, sh_display from v_curr_obj_lead_pers) lead on lead.obj = o.sid left outer join (select obj, sh_obj, sh_display from v_curr_obj_owning_unit) ou on ou.obj = o.sid left outer join (select obj, sh_obj, sh_display from v_curr_obj_create_unit) cu on cu.obj = o.sid left outer join (select obj, sh_obj, sh_display from v_curr_obj_receiving_unit) ru on ru.obj = o.sid left outer join mv_acm_status_history vs on vs.obj = o.sid and vs.completed_on is null inner join mv_acm_status stat on stat.sid = vs.status left outer join (select ir.obj, ar.display from mv_i_referral ir left outer join mv_acm_reference ar on ir.orig_receipt_method = ar.ref_key) ref on ref.obj = o.sid LEFT OUTER JOIN (SELECT OBJ, LISTAGG(PARTIC_OBJ, ';' || chr(10)) WITHIN GROUP( ORDER BY INVOLV_SID ) SUBJECTS, LISTAGG(OFFICE,chr(10)) WITHIN GROUP ( ORDER BY PARTICIPANT_NAME ) OFFICE FROM V_OBJ_PARTICIPANTS WHERE CODE = 'SUBJECT' GROUP BY OBJ ) OP ON OP.OBJ = O.SID |
TEXT_VC | select o.sid obj, o.id id, o.tagline title, o.created_on, stat.display status, lead.sh_display lead, ou.sh_display owning_unit, cu.sh_display create_unit, ru.sh_display rcv_unit, ot.display referral_type, o.next_due_date, o.final_due_date, o.created_on_fy created_on_fy, o.last_modified_on last_modified_date, ref.display source, OP.SUBJECTS, OP.OFFICE from mv_acm_obj o inner join mv_acm_obj_type ot on o.obj_type = ot.sid and ot.obj_root in ('INTERCOM') left outer join (select obj, sh_obj, sh_display from v_curr_obj_lead_pers) lead on lead.obj = o.sid left outer join (select obj, sh_obj, sh_display from v_curr_obj_owning_unit) ou on ou.obj = o.sid left outer join (select obj, sh_obj, sh_display from v_curr_obj_create_unit) cu on cu.obj = o.sid left outer join (select obj, sh_obj, sh_display from v_curr_obj_receiving_unit) ru on ru.obj = o.sid left outer join mv_acm_status_history vs on vs.obj = o.sid and vs.completed_on is null inner join mv_acm_status stat on stat.sid = vs.status left outer join (select ir.obj, ar.display from mv_i_referral ir left outer join mv_acm_reference ar on ir.orig_receipt_method = ar.ref_key) ref on ref.obj = o.sid LEFT OUTER JOIN (SELECT OBJ, LISTAGG(PARTIC_OBJ, ';' || chr(10)) WITHIN GROUP( ORDER BY INVOLV_SID ) SUBJECTS, LISTAGG(OFFICE,chr(10)) WITHIN GROUP ( ORDER BY PARTICIPANT_NAME ) OFFICE FROM V_OBJ_PARTICIPANTS WHERE CODE = 'SUBJECT' GROUP BY OBJ ) OP ON OP.OBJ = O.SID |
TYPE_TEXT_LENGTH | null |
TYPE_TEXT | null |
OID_TEXT_LENGTH | null |
OID_TEXT | null |
VIEW_TYPE_OWNER | null |
VIEW_TYPE | null |
SUPERVIEW_NAME | null |
EDITIONING_VIEW | N |
READ_ONLY | N |
CONTAINER_DATA | N |
BEQUEATH | DEFINER |
ORIGIN_CON_ID | 16 |
DEFAULT_COLLATION | USING_NLS_COMP |
CONTAINERS_DEFAULT | NO |
CONTAINER_MAP | NO |
EXTENDED_DATA_LINK | NO |
EXTENDED_DATA_LINK_MAP | NO |
HAS_SENSITIVE_COLUMN | NO |
ADMIT_NULL | NO |
PDB_LOCAL_ONLY | NO |
DUPLICATED | N |
SHARDED | N |
OWNER | TRIGGER_NAME | TRIGGER_TYPE | TRIGGERING_EVENT | STATUS | OBJECT_ID |
---|
ATTRIBUTE | Line:Position | TEXT |
---|